Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 266691 |
| Missing cells | 13199 |
| Missing cells (%) | 0.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 72.4 MiB |
| Average record size in memory | 284.8 B |
Variable types
| NUM | 10 |
|---|---|
| CAT | 3 |
Reproduction
| Analysis started | 2020-05-28 08:51:13.649572 |
|---|---|
| Analysis finished | 2020-05-28 08:51:51.797275 |
| Duration | 38.15 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
brand has constant value "Globe Postpaid" | Constant |
cellId has a high cardinality: 266690 distinct values | High cardinality |
unitId has a high cardinality: 9534 distinct values | High cardinality |
revenueData is highly correlated with data and 2 other fields | High correlation |
data is highly correlated with revenueData and 1 other fields | High correlation |
sms is highly correlated with revenueData and 1 other fields | High correlation |
revenueVoice is highly correlated with voice and 1 other fields | High correlation |
voice is highly correlated with revenueVoice and 1 other fields | High correlation |
revenueSms is highly correlated with data and 4 other fields | High correlation |
unitId has 13198 (4.9%) missing values | Missing |
data is highly skewed (γ1 = 507.4377743) | Skewed |
voice is highly skewed (γ1 = 344.228712) | Skewed |
sms is highly skewed (γ1 = 393.2152103) | Skewed |
revenueData is highly skewed (γ1 = 509.488547) | Skewed |
revenueVoice is highly skewed (γ1 = 346.2313916) | Skewed |
revenueSms is highly skewed (γ1 = 467.6719718) | Skewed |
yieldData is highly skewed (γ1 = 500.3643936) | Skewed |
yieldSms is highly skewed (γ1 = 33.91918453) | Skewed |
dataScaleFactor is highly skewed (γ1 = 505.5685903) | Skewed |
cellId is uniformly distributed | Uniform |
voice has 124571 (46.7%) zeros | Zeros |
sms has 124111 (46.5%) zeros | Zeros |
revenueVoice has 124643 (46.7%) zeros | Zeros |
revenueSms has 124168 (46.6%) zeros | Zeros |
yieldVoice has 124643 (46.7%) zeros | Zeros |
yieldSms has 124168 (46.6%) zeros | Zeros |
| Distinct count | 266690 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 2.0 MiB |
| STALUCIAJ-I_4RFS | 1 |
|---|---|
| VIRRAMALJ-I_4RFS | 1 |
| CARCBUZ-RA | 1 |
| ALFONSO2Z-B | 1 |
| ALAEZ-B | 1 |
| Other values (266685) |
| Value | Count | Frequency (%) | |
| STALUCIAJ-I_4RFS | 1 | < 0.1% | |
| VIRRAMALJ-I_4RFS | 1 | < 0.1% | |
| CARCBUZ-RA | 1 | < 0.1% | |
| ALFONSO2Z-B | 1 | < 0.1% | |
| ALAEZ-B | 1 | < 0.1% | |
| LEONRDOSTJ-4 | 1 | < 0.1% | |
| LORENZOTANL-172 | 1 | < 0.1% | |
| SFLU4H-41 | 1 | < 0.1% | |
| SNICOLPAMH-42 | 1 | < 0.1% | |
| SAMPALOCLAGH-43 | 1 | < 0.1% | |
| ALTVISH-52 | 1 | < 0.1% | |
| SMCSJOSERZLH-43 | 1 | < 0.1% | |
| KIAMBAH-32 | 1 | < 0.1% | |
| GTZAMBOFOCIDZ-A | 1 | < 0.1% | |
| MAMBL2H-52 | 1 | < 0.1% | |
| TOWER2ONEF-11 | 1 | < 0.1% | |
| PBURGOSZ-L2 | 1 | < 0.1% | |
| CRISTOBALK-143 | 1 | < 0.1% | |
| WASHINK-131 | 1 | < 0.1% | |
| FAIRVIEWF-1 | 1 | < 0.1% | |
| TAYTAYCENK-131 | 1 | < 0.1% | |
| MATALATALAF-13 | 1 | < 0.1% | |
| TIBUNGF-12 | 1 | < 0.1% | |
| OZAMIS-1 | 1 | < 0.1% | |
| NEPODAGUPIDJ-C_4RFS | 1 | < 0.1% | |
| Other values (266665) | 266665 | > 99.9% |
Length
| Max length | 36 |
|---|---|
| Median length | 12 |
| Mean length | 12.87280786 |
| Min length | 3 |
Most occurring characters
| Value | Count | Frequency (%) | |
| A | 379276 | 11.0% | |
| - | 266690 | 7.8% | |
| N | 179866 | 5.2% | |
| L | 179457 | 5.2% | |
| S | 171932 | 5.0% | |
| R | 170235 | 5.0% | |
| 1 | 139065 | 4.1% | |
| I | 136883 | 4.0% | |
| O | 136840 | 4.0% | |
| C | 125753 | 3.7% | |
| T | 121622 | 3.5% | |
| B | 111913 | 3.3% | |
| M | 107611 | 3.1% | |
| E | 103317 | 3.0% | |
| F | 101140 | 2.9% | |
| G | 95427 | 2.8% | |
| 3 | 92544 | 2.7% | |
| 2 | 85919 | 2.5% | |
| Z | 85661 | 2.5% | |
| U | 82636 | 2.4% | |
| P | 74344 | 2.2% | |
| D | 71726 | 2.1% | |
| H | 69252 | 2.0% | |
| 4 | 62994 | 1.8% | |
| J | 55227 | 1.6% | |
| Other values (21) | 225732 | 6.6% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Uppercase Letter | 2713336 | 79.0% | |
| Decimal Number | 416415 | 12.1% | |
| Dash Punctuation | 266690 | 7.8% | |
| Connector Punctuation | 36574 | 1.1% | |
| Lowercase Letter | 32 | < 0.1% | |
| Space Separator | 15 | < 0.1% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| A | 379276 | 14.0% | |
| N | 179866 | 6.6% | |
| L | 179457 | 6.6% | |
| S | 171932 | 6.3% | |
| R | 170235 | 6.3% | |
| I | 136883 | 5.0% | |
| O | 136840 | 5.0% | |
| C | 125753 | 4.6% | |
| T | 121622 | 4.5% | |
| B | 111913 | 4.1% | |
| M | 107611 | 4.0% | |
| E | 103317 | 3.8% | |
| F | 101140 | 3.7% | |
| G | 95427 | 3.5% | |
| Z | 85661 | 3.2% | |
| U | 82636 | 3.0% | |
| P | 74344 | 2.7% | |
| D | 71726 | 2.6% | |
| H | 69252 | 2.6% | |
| J | 55227 | 2.0% | |
| K | 39016 | 1.4% | |
| V | 35784 | 1.3% | |
| Y | 34668 | 1.3% | |
| W | 19362 | 0.7% | |
| Q | 13074 | 0.5% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 266690 | 100.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 1 | 139065 | 33.4% | |
| 3 | 92544 | 22.2% | |
| 2 | 85919 | 20.6% | |
| 4 | 62994 | 15.1% | |
| 7 | 16505 | 4.0% | |
| 6 | 7250 | 1.7% | |
| 0 | 6234 | 1.5% | |
| 5 | 4348 | 1.0% | |
| 8 | 906 | 0.2% | |
| 9 | 650 | 0.2% |
Most frequent Connector Punctuation characters
| Value | Count | Frequency (%) | |
| _ | 36574 | 100.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 15 | 100.0% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| l | 8 | 25.0% | |
| s | 6 | 18.8% | |
| n | 5 | 15.6% | |
| a | 4 | 12.5% | |
| c | 3 | 9.4% | |
| r | 3 | 9.4% | |
| o | 3 | 9.4% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 2713368 | 79.0% | |
| Common | 719694 | 21.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| A | 379276 | 14.0% | |
| N | 179866 | 6.6% | |
| L | 179457 | 6.6% | |
| S | 171932 | 6.3% | |
| R | 170235 | 6.3% | |
| I | 136883 | 5.0% | |
| O | 136840 | 5.0% | |
| C | 125753 | 4.6% | |
| T | 121622 | 4.5% | |
| B | 111913 | 4.1% | |
| M | 107611 | 4.0% | |
| E | 103317 | 3.8% | |
| F | 101140 | 3.7% | |
| G | 95427 | 3.5% | |
| Z | 85661 | 3.2% | |
| U | 82636 | 3.0% | |
| P | 74344 | 2.7% | |
| D | 71726 | 2.6% | |
| H | 69252 | 2.6% | |
| J | 55227 | 2.0% | |
| K | 39016 | 1.4% | |
| V | 35784 | 1.3% | |
| Y | 34668 | 1.3% | |
| W | 19362 | 0.7% | |
| Q | 13074 | 0.5% | |
| Other values (8) | 11346 | 0.4% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| - | 266690 | 37.1% | |
| 1 | 139065 | 19.3% | |
| 3 | 92544 | 12.9% | |
| 2 | 85919 | 11.9% | |
| 4 | 62994 | 8.8% | |
| _ | 36574 | 5.1% | |
| 7 | 16505 | 2.3% | |
| 6 | 7250 | 1.0% | |
| 0 | 6234 | 0.9% | |
| 5 | 4348 | 0.6% | |
| 8 | 906 | 0.1% | |
| 9 | 650 | 0.1% | |
| 15 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 3433062 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| A | 379276 | 11.0% | |
| - | 266690 | 7.8% | |
| N | 179866 | 5.2% | |
| L | 179457 | 5.2% | |
| S | 171932 | 5.0% | |
| R | 170235 | 5.0% | |
| 1 | 139065 | 4.1% | |
| I | 136883 | 4.0% | |
| O | 136840 | 4.0% | |
| C | 125753 | 3.7% | |
| T | 121622 | 3.5% | |
| B | 111913 | 3.3% | |
| M | 107611 | 3.1% | |
| E | 103317 | 3.0% | |
| F | 101140 | 2.9% | |
| G | 95427 | 2.8% | |
| 3 | 92544 | 2.7% | |
| 2 | 85919 | 2.5% | |
| Z | 85661 | 2.5% | |
| U | 82636 | 2.4% | |
| P | 74344 | 2.2% | |
| D | 71726 | 2.1% | |
| H | 69252 | 2.0% | |
| 4 | 62994 | 1.8% | |
| J | 55227 | 1.6% | |
| Other values (21) | 225732 | 6.6% |
| Distinct count | 265204 |
|---|---|
| Unique (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43462.27619601458 |
|---|---|
| Minimum | 0.0 |
| Maximum | 459636600.3531999 |
| Zeros | 599 |
| Zeros (%) | 0.2% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 34.58408498 |
| Q1 | 1794.753161 |
| median | 9912.397559 |
| Q3 | 35339.98161 |
| 95-th percentile | 197706.4997 |
| Maximum | 459636600.4 |
| Range | 459636600.4 |
| Interquartile range (IQR) | 33545.22845 |
Descriptive statistics
| Standard deviation | 895186.5912 |
|---|---|
| Coefficient of variation (CV) | 20.59686398 |
| Kurtosis | 260518.1124 |
| Mean | 43462.2762 |
| Median Absolute Deviation (MAD) | 9514.414659 |
| Skewness | 507.4377743 |
| Sum | 1.15909979e+10 |
| Variance | 8.01359033e+11 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 599 | 0.2% | |
| 0.0003 | 30 | < 0.1% | |
| 0.0002 | 29 | < 0.1% | |
| 0.0004 | 17 | < 0.1% | |
| 0.001 | 14 | < 0.1% | |
| 0.0007 | 14 | < 0.1% | |
| 0.0015 | 14 | < 0.1% | |
| 0.0016 | 13 | < 0.1% | |
| 0.0012 | 13 | < 0.1% | |
| 0.0001 | 13 | < 0.1% | |
| 0.0006 | 13 | < 0.1% | |
| 0.0005 | 13 | < 0.1% | |
| 0.0057 | 11 | < 0.1% | |
| 0.002 | 11 | < 0.1% | |
| 0.0011 | 11 | < 0.1% | |
| 0.0022 | 11 | < 0.1% | |
| 0.0035 | 10 | < 0.1% | |
| 0.0018 | 10 | < 0.1% | |
| 0.0038 | 9 | < 0.1% | |
| 0.0019 | 9 | < 0.1% | |
| 0.0026 | 9 | < 0.1% | |
| 0.0013 | 9 | < 0.1% | |
| 0.0034 | 9 | < 0.1% | |
| 0.0031 | 9 | < 0.1% | |
| 0.0014 | 9 | < 0.1% | |
| Other values (265179) | 265782 | 99.7% |
| Value | Count | Frequency (%) | |
| 0 | 599 | 0.2% | |
| 8.693003778e-06 | 1 | < 0.1% | |
| 9.132211955e-06 | 1 | < 0.1% | |
| 3.162021001e-05 | 1 | < 0.1% | |
| 5.045368632e-05 | 1 | < 0.1% | |
| 5.619877416e-05 | 1 | < 0.1% | |
| 6.511585038e-05 | 1 | < 0.1% | |
| 0.0001 | 13 | < 0.1% | |
| 0.0001126942896 | 1 | < 0.1% | |
| 0.000137855798 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 459636600.4 | 1 | < 0.1% | |
| 3389193.597 | 1 | < 0.1% | |
| 3161778.071 | 1 | < 0.1% | |
| 2482581.137 | 1 | < 0.1% | |
| 2444452.822 | 1 | < 0.1% | |
| 2423076.228 | 1 | < 0.1% | |
| 2293691.189 | 1 | < 0.1% | |
| 2177162.436 | 1 | < 0.1% | |
| 2054240.185 | 1 | < 0.1% | |
| 2023448.271 | 1 | < 0.1% |
| Distinct count | 17691 |
|---|---|
| Unique (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1713.1626414089715 |
|---|---|
| Minimum | 0.0 |
| Maximum | 4166893.0 |
| Zeros | 124571 |
| Zeros (%) | 46.7% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 50 |
| Q3 | 1336 |
| 95-th percentile | 8664 |
| Maximum | 4166893 |
| Range | 4166893 |
| Interquartile range (IQR) | 1336 |
Descriptive statistics
| Standard deviation | 9239.866623 |
|---|---|
| Coefficient of variation (CV) | 5.393455589 |
| Kurtosis | 154838.32 |
| Mean | 1713.162641 |
| Median Absolute Deviation (MAD) | 50 |
| Skewness | 344.228712 |
| Sum | 456885058 |
| Variance | 85375135.22 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 124571 | 46.7% | |
| 1 | 372 | 0.1% | |
| 2 | 306 | 0.1% | |
| 4 | 279 | 0.1% | |
| 3 | 267 | 0.1% | |
| 5 | 251 | 0.1% | |
| 6 | 233 | 0.1% | |
| 9 | 223 | 0.1% | |
| 8 | 213 | 0.1% | |
| 7 | 212 | 0.1% | |
| 12 | 207 | 0.1% | |
| 21 | 192 | 0.1% | |
| 11 | 192 | 0.1% | |
| 15 | 191 | 0.1% | |
| 17 | 186 | 0.1% | |
| 14 | 186 | 0.1% | |
| 20 | 185 | 0.1% | |
| 10 | 183 | 0.1% | |
| 16 | 181 | 0.1% | |
| 18 | 181 | 0.1% | |
| 13 | 180 | 0.1% | |
| 25 | 173 | 0.1% | |
| 23 | 168 | 0.1% | |
| 24 | 166 | 0.1% | |
| 22 | 165 | 0.1% | |
| Other values (17666) | 137028 | 51.4% |
| Value | Count | Frequency (%) | |
| 0 | 124571 | 46.7% | |
| 1 | 372 | 0.1% | |
| 2 | 306 | 0.1% | |
| 3 | 267 | 0.1% | |
| 4 | 279 | 0.1% | |
| 5 | 251 | 0.1% | |
| 6 | 233 | 0.1% | |
| 7 | 212 | 0.1% | |
| 8 | 213 | 0.1% | |
| 9 | 223 | 0.1% |
| Value | Count | Frequency (%) | |
| 4166893 | 1 | < 0.1% | |
| 132374 | 1 | < 0.1% | |
| 122007 | 1 | < 0.1% | |
| 115706 | 1 | < 0.1% | |
| 114932 | 1 | < 0.1% | |
| 114431 | 1 | < 0.1% | |
| 114246 | 1 | < 0.1% | |
| 109170 | 1 | < 0.1% | |
| 108707 | 1 | < 0.1% | |
| 106731 | 1 | < 0.1% |
| Distinct count | 15303 |
|---|---|
| Unique (%) | 5.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1558.3958138819833 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7035146.0 |
| Zeros | 124111 |
| Zeros (%) | 46.5% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 78 |
| Q3 | 1450 |
| 95-th percentile | 7063 |
| Maximum | 7035146 |
| Range | 7035146 |
| Interquartile range (IQR) | 1450 |
Descriptive statistics
| Standard deviation | 15021.77779 |
|---|---|
| Coefficient of variation (CV) | 9.63925702 |
| Kurtosis | 180954.1736 |
| Mean | 1558.395814 |
| Median Absolute Deviation (MAD) | 78 |
| Skewness | 393.2152103 |
| Sum | 415610138 |
| Variance | 225653807.9 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 124111 | 46.5% | |
| 1 | 221 | 0.1% | |
| 2 | 196 | 0.1% | |
| 4 | 173 | 0.1% | |
| 3 | 169 | 0.1% | |
| 5 | 159 | 0.1% | |
| 12 | 157 | 0.1% | |
| 6 | 157 | 0.1% | |
| 8 | 155 | 0.1% | |
| 11 | 154 | 0.1% | |
| 9 | 154 | 0.1% | |
| 7 | 149 | 0.1% | |
| 10 | 149 | 0.1% | |
| 15 | 140 | 0.1% | |
| 19 | 140 | 0.1% | |
| 17 | 132 | < 0.1% | |
| 13 | 129 | < 0.1% | |
| 20 | 129 | < 0.1% | |
| 37 | 129 | < 0.1% | |
| 24 | 127 | < 0.1% | |
| 21 | 127 | < 0.1% | |
| 14 | 126 | < 0.1% | |
| 18 | 126 | < 0.1% | |
| 47 | 125 | < 0.1% | |
| 48 | 125 | < 0.1% | |
| Other values (15278) | 139032 | 52.1% |
| Value | Count | Frequency (%) | |
| 0 | 124111 | 46.5% | |
| 1 | 221 | 0.1% | |
| 2 | 196 | 0.1% | |
| 3 | 169 | 0.1% | |
| 4 | 173 | 0.1% | |
| 5 | 159 | 0.1% | |
| 6 | 157 | 0.1% | |
| 7 | 149 | 0.1% | |
| 8 | 155 | 0.1% | |
| 9 | 154 | 0.1% |
| Value | Count | Frequency (%) | |
| 7035146 | 1 | < 0.1% | |
| 1515235 | 1 | < 0.1% | |
| 1431694 | 1 | < 0.1% | |
| 588032 | 1 | < 0.1% | |
| 547934 | 1 | < 0.1% | |
| 526645 | 1 | < 0.1% | |
| 429697 | 1 | < 0.1% | |
| 422685 | 1 | < 0.1% | |
| 391412 | 1 | < 0.1% | |
| 341987 | 1 | < 0.1% |
| Distinct count | 266013 |
|---|---|
| Unique (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3656.8748307717538 |
|---|---|
| Minimum | 0.0 |
| Maximum | 48413063.70517743 |
| Zeros | 678 |
| Zeros (%) | 0.3% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.065318163 |
| Q1 | 138.9876864 |
| median | 757.9046195 |
| Q3 | 2658.810992 |
| 95-th percentile | 16451.29867 |
| Maximum | 48413063.71 |
| Range | 48413063.71 |
| Interquartile range (IQR) | 2519.823305 |
Descriptive statistics
| Standard deviation | 94164.12424 |
|---|---|
| Coefficient of variation (CV) | 25.74988989 |
| Kurtosis | 261923.9641 |
| Mean | 3656.874831 |
| Median Absolute Deviation (MAD) | 727.1004008 |
| Skewness | 509.488547 |
| Sum | 975255605.5 |
| Variance | 8866882294 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 678 | 0.3% | |
| 4.587505425e-05 | 2 | < 0.1% | |
| 53.84588586 | 1 | < 0.1% | |
| 738.4974195 | 1 | < 0.1% | |
| 1828.777086 | 1 | < 0.1% | |
| 24.33377088 | 1 | < 0.1% | |
| 80.24648321 | 1 | < 0.1% | |
| 17402.74098 | 1 | < 0.1% | |
| 89.31746365 | 1 | < 0.1% | |
| 1960.135488 | 1 | < 0.1% | |
| 31730.662 | 1 | < 0.1% | |
| 2428.827788 | 1 | < 0.1% | |
| 2449.772954 | 1 | < 0.1% | |
| 492.3924246 | 1 | < 0.1% | |
| 73.1381679 | 1 | < 0.1% | |
| 411.5659128 | 1 | < 0.1% | |
| 11.94333033 | 1 | < 0.1% | |
| 241.2327727 | 1 | < 0.1% | |
| 5120.719547 | 1 | < 0.1% | |
| 64.60681913 | 1 | < 0.1% | |
| 416.90039 | 1 | < 0.1% | |
| 362.36244 | 1 | < 0.1% | |
| 8069.681171 | 1 | < 0.1% | |
| 6585.880816 | 1 | < 0.1% | |
| 0.07297258124 | 1 | < 0.1% | |
| Other values (265988) | 265988 | 99.7% |
| Value | Count | Frequency (%) | |
| 0 | 678 | 0.3% | |
| 1.99779855e-07 | 1 | < 0.1% | |
| 4.796649247e-07 | 1 | < 0.1% | |
| 5.279659965e-07 | 1 | < 0.1% | |
| 6.984846579e-07 | 1 | < 0.1% | |
| 7.661235011e-07 | 1 | < 0.1% | |
| 7.721764916e-07 | 1 | < 0.1% | |
| 1.101797357e-06 | 1 | < 0.1% | |
| 1.1124283e-06 | 1 | < 0.1% | |
| 1.469063142e-06 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 48413063.71 | 1 | < 0.1% | |
| 374550.2061 | 1 | < 0.1% | |
| 324289.3603 | 1 | < 0.1% | |
| 260554.038 | 1 | < 0.1% | |
| 234407.7431 | 1 | < 0.1% | |
| 231737.4204 | 1 | < 0.1% | |
| 225302.6924 | 1 | < 0.1% | |
| 210042.7454 | 1 | < 0.1% | |
| 199884.7852 | 1 | < 0.1% | |
| 197643.9537 | 1 | < 0.1% |
| Distinct count | 142036 |
|---|---|
| Unique (%) | 53.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2798.05934006934 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7304538.566859882 |
| Zeros | 124643 |
| Zeros (%) | 46.7% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 63.09816916 |
| Q3 | 1850.96798 |
| 95-th percentile | 14619.64839 |
| Maximum | 7304538.567 |
| Range | 7304538.567 |
| Interquartile range (IQR) | 1850.96798 |
Descriptive statistics
| Standard deviation | 16166.6324 |
|---|---|
| Coefficient of variation (CV) | 5.77780184 |
| Kurtosis | 156039.1861 |
| Mean | 2798.05934 |
| Median Absolute Deviation (MAD) | 63.09816916 |
| Skewness | 346.2313916 |
| Sum | 746217243.5 |
| Variance | 261360003.2 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 124643 | 46.7% | |
| 0.5523870838 | 2 | < 0.1% | |
| 3.679482082 | 2 | < 0.1% | |
| 2.409790837 | 2 | < 0.1% | |
| 1.282726574 | 2 | < 0.1% | |
| 0.6566683522 | 2 | < 0.1% | |
| 0.4131777458 | 2 | < 0.1% | |
| 0.6769091689 | 2 | < 0.1% | |
| 1.43466435 | 2 | < 0.1% | |
| 5.13608518 | 2 | < 0.1% | |
| 2.299502501 | 2 | < 0.1% | |
| 1.918619699 | 2 | < 0.1% | |
| 0.7804449779 | 2 | < 0.1% | |
| 3.74418824 | 2 | < 0.1% | |
| 17957.87827 | 1 | < 0.1% | |
| 192.5757798 | 1 | < 0.1% | |
| 260.0389457 | 1 | < 0.1% | |
| 438.1793187 | 1 | < 0.1% | |
| 407.3196599 | 1 | < 0.1% | |
| 1901.673318 | 1 | < 0.1% | |
| 343.7521346 | 1 | < 0.1% | |
| 850.3961516 | 1 | < 0.1% | |
| 2452.461182 | 1 | < 0.1% | |
| 710.7691662 | 1 | < 0.1% | |
| 5497.230543 | 1 | < 0.1% | |
| Other values (142011) | 142011 | 53.2% |
| Value | Count | Frequency (%) | |
| 0 | 124643 | 46.7% | |
| 0.06065764082 | 1 | < 0.1% | |
| 0.06441259384 | 1 | < 0.1% | |
| 0.07177761533 | 1 | < 0.1% | |
| 0.1127964137 | 1 | < 0.1% | |
| 0.1314788038 | 1 | < 0.1% | |
| 0.1320822475 | 1 | < 0.1% | |
| 0.1367202098 | 1 | < 0.1% | |
| 0.1496294982 | 1 | < 0.1% | |
| 0.1618641161 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7304538.567 | 1 | < 0.1% | |
| 272198.241 | 1 | < 0.1% | |
| 207280.5471 | 1 | < 0.1% | |
| 202273.8755 | 1 | < 0.1% | |
| 197374.0008 | 1 | < 0.1% | |
| 185707.2221 | 1 | < 0.1% | |
| 184748.4015 | 1 | < 0.1% | |
| 175923.9807 | 1 | < 0.1% | |
| 175365.196 | 1 | < 0.1% | |
| 174553.4158 | 1 | < 0.1% |
| Distinct count | 142514 |
|---|---|
| Unique (%) | 53.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1549.7010156578885 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7398027.683505454 |
| Zeros | 124168 |
| Zeros (%) | 46.6% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 71.09182077 |
| Q3 | 1500.724922 |
| 95-th percentile | 7218.960124 |
| Maximum | 7398027.684 |
| Range | 7398027.684 |
| Interquartile range (IQR) | 1500.724922 |
Descriptive statistics
| Standard deviation | 14805.14409 |
|---|---|
| Coefficient of variation (CV) | 9.553548681 |
| Kurtosis | 233586.3882 |
| Mean | 1549.701016 |
| Median Absolute Deviation (MAD) | 71.09182077 |
| Skewness | 467.6719718 |
| Sum | 413291313.6 |
| Variance | 219192291.6 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 124168 | 46.6% | |
| 5.975750029 | 2 | < 0.1% | |
| 16.6159636 | 2 | < 0.1% | |
| 1.759665301 | 2 | < 0.1% | |
| 0.2881737499 | 2 | < 0.1% | |
| 0.64041899 | 2 | < 0.1% | |
| 0.6415415915 | 2 | < 0.1% | |
| 0.04747249824 | 2 | < 0.1% | |
| 6.438991447 | 2 | < 0.1% | |
| 2.544838621 | 2 | < 0.1% | |
| 2.757149884 | 2 | < 0.1% | |
| 683.0530136 | 1 | < 0.1% | |
| 1069.781967 | 1 | < 0.1% | |
| 83.73684345 | 1 | < 0.1% | |
| 2750.536729 | 1 | < 0.1% | |
| 1787.550876 | 1 | < 0.1% | |
| 444.669935 | 1 | < 0.1% | |
| 2767.439401 | 1 | < 0.1% | |
| 7713.085109 | 1 | < 0.1% | |
| 1146.323655 | 1 | < 0.1% | |
| 2378.846113 | 1 | < 0.1% | |
| 615.0469844 | 1 | < 0.1% | |
| 922.6936886 | 1 | < 0.1% | |
| 2940.929907 | 1 | < 0.1% | |
| 741.6430738 | 1 | < 0.1% | |
| Other values (142489) | 142489 | 53.4% |
| Value | Count | Frequency (%) | |
| 0 | 124168 | 46.6% | |
| 0.0002846958365 | 1 | < 0.1% | |
| 0.0004300061719 | 1 | < 0.1% | |
| 0.0008029093694 | 1 | < 0.1% | |
| 0.003365325295 | 1 | < 0.1% | |
| 0.003383980067 | 1 | < 0.1% | |
| 0.003919756791 | 1 | < 0.1% | |
| 0.00447676277 | 1 | < 0.1% | |
| 0.00474759912 | 1 | < 0.1% | |
| 0.005273175454 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7398027.684 | 1 | < 0.1% | |
| 123441.7735 | 1 | < 0.1% | |
| 118153.8089 | 1 | < 0.1% | |
| 109397.9406 | 1 | < 0.1% | |
| 107507.1401 | 1 | < 0.1% | |
| 105932.4892 | 1 | < 0.1% | |
| 103742.1008 | 1 | < 0.1% | |
| 99919.96459 | 1 | < 0.1% | |
| 96590.56529 | 1 | < 0.1% | |
| 95536.83339 | 1 | < 0.1% |
| Distinct count | 265951 |
|---|---|
| Unique (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08860814573027018 |
|---|---|
| Minimum | 0.0 |
| Maximum | 577.1884074485318 |
| Zeros | 678 |
| Zeros (%) | 0.3% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.02897523099 |
| Q1 | 0.06115838414 |
| median | 0.08115910213 |
| Q3 | 0.1006106922 |
| 95-th percentile | 0.1420108304 |
| Maximum | 577.1884074 |
| Range | 577.1884074 |
| Interquartile range (IQR) | 0.03945230804 |
Descriptive statistics
| Standard deviation | 1.129661413 |
|---|---|
| Coefficient of variation (CV) | 12.74895669 |
| Kurtosis | 255405.4317 |
| Mean | 0.08860814573 |
| Median Absolute Deviation (MAD) | 0.01971499979 |
| Skewness | 500.3643936 |
| Sum | 23630.99499 |
| Variance | 1.276134907 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 678 | 0.3% | |
| 0.01210107937 | 4 | < 0.1% | |
| 0.003860882458 | 4 | < 0.1% | |
| 0.003860882458 | 3 | < 0.1% | |
| 0.02451494893 | 3 | < 0.1% | |
| 0.06543012534 | 2 | < 0.1% | |
| 0.08042214054 | 2 | < 0.1% | |
| 0.01298069044 | 2 | < 0.1% | |
| 1.215898146 | 2 | < 0.1% | |
| 0.1491854946 | 2 | < 0.1% | |
| 0.01741161218 | 2 | < 0.1% | |
| 0.08416387089 | 2 | < 0.1% | |
| 0.03577614547 | 2 | < 0.1% | |
| 0.04170459477 | 2 | < 0.1% | |
| 0.01853999626 | 2 | < 0.1% | |
| 0.01597298762 | 2 | < 0.1% | |
| 0.01461906084 | 2 | < 0.1% | |
| 0.1330175808 | 2 | < 0.1% | |
| 0.00388915583 | 2 | < 0.1% | |
| 0.1602644269 | 2 | < 0.1% | |
| 0.06654124034 | 2 | < 0.1% | |
| 0.09949059029 | 2 | < 0.1% | |
| 0.5306101492 | 2 | < 0.1% | |
| 0.1463874687 | 2 | < 0.1% | |
| 0.007242619926 | 2 | < 0.1% | |
| Other values (265926) | 265959 | 99.7% |
| Value | Count | Frequency (%) | |
| 0 | 678 | 0.3% | |
| 4.461660903e-08 | 1 | < 0.1% | |
| 2.18388152e-07 | 1 | < 0.1% | |
| 2.189515125e-07 | 1 | < 0.1% | |
| 5.165946026e-07 | 1 | < 0.1% | |
| 6.986375115e-07 | 1 | < 0.1% | |
| 1.015945527e-06 | 1 | < 0.1% | |
| 1.580358449e-06 | 1 | < 0.1% | |
| 1.84733864e-06 | 1 | < 0.1% | |
| 4.24829652e-06 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 577.1884074 | 1 | < 0.1% | |
| 41.91586182 | 1 | < 0.1% | |
| 34.97200978 | 1 | < 0.1% | |
| 25.24322428 | 1 | < 0.1% | |
| 22.01140159 | 1 | < 0.1% | |
| 20.39113327 | 1 | < 0.1% | |
| 15.10431085 | 1 | < 0.1% | |
| 12.65643858 | 1 | < 0.1% | |
| 12.60413345 | 1 | < 0.1% | |
| 11.59775443 | 1 | < 0.1% |
| Distinct count | 141993 |
|---|---|
| Unique (%) | 53.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8226020813040287 |
|---|---|
| Minimum | 0.0 |
| Maximum | 131.4702993387589 |
| Zeros | 124643 |
| Zeros (%) | 46.7% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.7350170214 |
| Q3 | 1.540280851 |
| 95-th percentile | 2.207640722 |
| Maximum | 131.4702993 |
| Range | 131.4702993 |
| Interquartile range (IQR) | 1.540280851 |
Descriptive statistics
| Standard deviation | 0.9871049906 |
|---|---|
| Coefficient of variation (CV) | 1.199978718 |
| Kurtosis | 1647.686069 |
| Mean | 0.8226020813 |
| Median Absolute Deviation (MAD) | 0.7350170214 |
| Skewness | 15.63054775 |
| Sum | 219380.5717 |
| Variance | 0.9743762624 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 124643 | 46.7% | |
| 3.064367439 | 3 | < 0.1% | |
| 0.4131777458 | 3 | < 0.1% | |
| 0.6960185663 | 3 | < 0.1% | |
| 0.9360470601 | 3 | < 0.1% | |
| 3.679482082 | 2 | < 0.1% | |
| 0.70074149 | 2 | < 0.1% | |
| 0.5728699382 | 2 | < 0.1% | |
| 10.23690279 | 2 | < 0.1% | |
| 0.5523870838 | 2 | < 0.1% | |
| 0.6246307019 | 2 | < 0.1% | |
| 1.870424186 | 2 | < 0.1% | |
| 5.13608518 | 2 | < 0.1% | |
| 1.339199834 | 2 | < 0.1% | |
| 0.8148164081 | 2 | < 0.1% | |
| 0.2993398879 | 2 | < 0.1% | |
| 1.683037706 | 2 | < 0.1% | |
| 0.8530656413 | 2 | < 0.1% | |
| 5.97390696 | 2 | < 0.1% | |
| 0.7699114452 | 2 | < 0.1% | |
| 0.2355097267 | 2 | < 0.1% | |
| 1.098313902 | 2 | < 0.1% | |
| 0.6539921539 | 2 | < 0.1% | |
| 1.245068182 | 2 | < 0.1% | |
| 23.87365407 | 2 | < 0.1% | |
| Other values (141968) | 141996 | 53.2% |
| Value | Count | Frequency (%) | |
| 0 | 124643 | 46.7% | |
| 0.01320822475 | 1 | < 0.1% | |
| 0.01505658523 | 1 | < 0.1% | |
| 0.02147086461 | 1 | < 0.1% | |
| 0.02620677552 | 1 | < 0.1% | |
| 0.02804298459 | 1 | < 0.1% | |
| 0.0296433105 | 1 | < 0.1% | |
| 0.03288747469 | 1 | < 0.1% | |
| 0.03417103655 | 1 | < 0.1% | |
| 0.03565716896 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 131.4702993 | 1 | < 0.1% | |
| 102.8441623 | 1 | < 0.1% | |
| 45.73921683 | 1 | < 0.1% | |
| 41.86125846 | 1 | < 0.1% | |
| 39.50752947 | 1 | < 0.1% | |
| 39.49073765 | 1 | < 0.1% | |
| 38.13307446 | 1 | < 0.1% | |
| 29.92817032 | 1 | < 0.1% | |
| 23.87365407 | 2 | < 0.1% | |
| 23.34423797 | 1 | < 0.1% |
| Distinct count | 142497 |
|---|---|
| Unique (%) | 53.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6324937135912497 |
|---|---|
| Minimum | 0.0 |
| Maximum | 158.3961530856573 |
| Zeros | 124168 |
| Zeros (%) | 46.6% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.4210379211 |
| Q3 | 1.100916454 |
| 95-th percentile | 1.86326396 |
| Maximum | 158.3961531 |
| Range | 158.3961531 |
| Interquartile range (IQR) | 1.100916454 |
Descriptive statistics
| Standard deviation | 1.013739341 |
|---|---|
| Coefficient of variation (CV) | 1.602765876 |
| Kurtosis | 3719.927725 |
| Mean | 0.6324937136 |
| Median Absolute Deviation (MAD) | 0.4210379211 |
| Skewness | 33.91918453 |
| Sum | 168680.381 |
| Variance | 1.027667452 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 124168 | 46.6% | |
| 0.8567419473 | 3 | < 0.1% | |
| 3.75167234 | 3 | < 0.1% | |
| 0.144086875 | 3 | < 0.1% | |
| 0.005273175454 | 2 | < 0.1% | |
| 0.6096799158 | 2 | < 0.1% | |
| 0.08947459642 | 2 | < 0.1% | |
| 0.001909069497 | 2 | < 0.1% | |
| 0.008877146477 | 2 | < 0.1% | |
| 1.609747862 | 2 | < 0.1% | |
| 2.150832383 | 2 | < 0.1% | |
| 0.5179477966 | 2 | < 0.1% | |
| 0.09387276699 | 2 | < 0.1% | |
| 1.272419311 | 2 | < 0.1% | |
| 0.3207707958 | 2 | < 0.1% | |
| 0.8786191382 | 2 | < 0.1% | |
| 1.760536555 | 2 | < 0.1% | |
| 19.40277778 | 2 | < 0.1% | |
| 1.759665301 | 2 | < 0.1% | |
| 1.052078736 | 2 | < 0.1% | |
| 0.04452101989 | 2 | < 0.1% | |
| 2.660590995 | 2 | < 0.1% | |
| 0.5976359624 | 2 | < 0.1% | |
| 0.6039552817 | 2 | < 0.1% | |
| 0.04747249824 | 2 | < 0.1% | |
| Other values (142472) | 142472 | 53.4% |
| Value | Count | Frequency (%) | |
| 0 | 124168 | 46.6% | |
| 0.000215003086 | 1 | < 0.1% | |
| 0.0002846958365 | 1 | < 0.1% | |
| 0.0004014546847 | 1 | < 0.1% | |
| 0.001161339825 | 1 | < 0.1% | |
| 0.00153524383 | 1 | < 0.1% | |
| 0.001742009737 | 1 | < 0.1% | |
| 0.001893842228 | 1 | < 0.1% | |
| 0.001909069497 | 2 | < 0.1% | |
| 0.001959878395 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 158.3961531 | 1 | < 0.1% | |
| 121.4807307 | 1 | < 0.1% | |
| 87.85703521 | 1 | < 0.1% | |
| 85.50583127 | 1 | < 0.1% | |
| 77.99835885 | 1 | < 0.1% | |
| 61.08123002 | 1 | < 0.1% | |
| 61.08123002 | 1 | < 0.1% | |
| 49.85481868 | 1 | < 0.1% | |
| 47.74544036 | 1 | < 0.1% | |
| 44.11403266 | 1 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| Globe Postpaid |
|---|
| Value | Count | Frequency (%) | |
| Globe Postpaid | 266691 | 100.0% |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Most occurring characters
| Value | Count | Frequency (%) | |
| o | 533382 | 14.3% | |
| G | 266691 | 7.1% | |
| l | 266691 | 7.1% | |
| b | 266691 | 7.1% | |
| e | 266691 | 7.1% | |
| 266691 | 7.1% | ||
| P | 266691 | 7.1% | |
| s | 266691 | 7.1% | |
| t | 266691 | 7.1% | |
| p | 266691 | 7.1% | |
| a | 266691 | 7.1% | |
| i | 266691 | 7.1% | |
| d | 266691 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 2933601 | 78.6% | |
| Uppercase Letter | 533382 | 14.3% | |
| Space Separator | 266691 | 7.1% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| G | 266691 | 50.0% | |
| P | 266691 | 50.0% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| o | 533382 | 18.2% | |
| l | 266691 | 9.1% | |
| b | 266691 | 9.1% | |
| e | 266691 | 9.1% | |
| s | 266691 | 9.1% | |
| t | 266691 | 9.1% | |
| p | 266691 | 9.1% | |
| a | 266691 | 9.1% | |
| i | 266691 | 9.1% | |
| d | 266691 | 9.1% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 266691 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 3466983 | 92.9% | |
| Common | 266691 | 7.1% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| o | 533382 | 15.4% | |
| G | 266691 | 7.7% | |
| l | 266691 | 7.7% | |
| b | 266691 | 7.7% | |
| e | 266691 | 7.7% | |
| P | 266691 | 7.7% | |
| s | 266691 | 7.7% | |
| t | 266691 | 7.7% | |
| p | 266691 | 7.7% | |
| a | 266691 | 7.7% | |
| i | 266691 | 7.7% | |
| d | 266691 | 7.7% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 266691 | 100.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 3733674 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| o | 533382 | 14.3% | |
| G | 266691 | 7.1% | |
| l | 266691 | 7.1% | |
| b | 266691 | 7.1% | |
| e | 266691 | 7.1% | |
| 266691 | 7.1% | ||
| P | 266691 | 7.1% | |
| s | 266691 | 7.1% | |
| t | 266691 | 7.1% | |
| p | 266691 | 7.1% | |
| a | 266691 | 7.1% | |
| i | 266691 | 7.1% | |
| d | 266691 | 7.1% |
| Distinct count | 9534 |
|---|---|
| Unique (%) | 3.8% |
| Missing | 13198 |
| Missing (%) | 4.9% |
| Memory size | 2.0 MiB |
| FCICTMALL | 65 |
|---|---|
| PEARLPLAZA2PQUENCRID | 64 |
| DAGUPAN3 | 60 |
| LIGAO | 60 |
| UNISITE | 60 |
| Other values (9529) |
| Value | Count | Frequency (%) | |
| FCICTMALL | 65 | < 0.1% | |
| PEARLPLAZA2PQUENCRID | 64 | < 0.1% | |
| DAGUPAN3 | 60 | < 0.1% | |
| LIGAO | 60 | < 0.1% | |
| UNISITE | 60 | < 0.1% | |
| DELROSAR | 60 | < 0.1% | |
| TANDAKUTYOTANAYRZL | 60 | < 0.1% | |
| PRINZA | 60 | < 0.1% | |
| ANGELWEST | 60 | < 0.1% | |
| MAGSAYSAY | 59 | < 0.1% | |
| CALPN2 | 59 | < 0.1% | |
| BLUMINTRE | 59 | < 0.1% | |
| SMHYPERM | 59 | < 0.1% | |
| SANNICHOL | 59 | < 0.1% | |
| 18EIGHTY | 59 | < 0.1% | |
| BACOOR2 | 59 | < 0.1% | |
| BTNGS2 | 59 | < 0.1% | |
| ELPUEBLO1 | 58 | < 0.1% | |
| MATIMBMAL | 58 | < 0.1% | |
| CARME2 | 58 | < 0.1% | |
| CENTEXML | 57 | < 0.1% | |
| SFPAGUSTN | 57 | < 0.1% | |
| CARGOHAUS | 57 | < 0.1% | |
| BAGUIO | 57 | < 0.1% | |
| CANERO | 57 | < 0.1% | |
| Other values (9509) | 252013 | 94.5% | |
| (Missing) | 13198 | 4.9% |
Length
| Max length | 25 |
|---|---|
| Median length | 8 |
| Mean length | 8.280455658 |
| Min length | 2 |
Most occurring characters
| Value | Count | Frequency (%) | |
| A | 341693 | 15.5% | |
| N | 168779 | 7.6% | |
| L | 144492 | 6.5% | |
| S | 128700 | 5.8% | |
| O | 128454 | 5.8% | |
| I | 127286 | 5.8% | |
| T | 113929 | 5.2% | |
| R | 109802 | 5.0% | |
| C | 102063 | 4.6% | |
| M | 99895 | 4.5% | |
| E | 95498 | 4.3% | |
| B | 90009 | 4.1% | |
| G | 88646 | 4.0% | |
| U | 78383 | 3.5% | |
| P | 70221 | 3.2% | |
| D | 65468 | 3.0% | |
| Y | 32701 | 1.5% | |
| V | 30194 | 1.4% | |
| n | 26399 | 1.2% | |
| H | 24910 | 1.1% | |
| K | 22690 | 1.0% | |
| W | 18010 | 0.8% | |
| 2 | 16179 | 0.7% | |
| Z | 14441 | 0.7% | |
| a | 13201 | 0.6% | |
| Other values (18) | 56280 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Uppercase Letter | 2134199 | 96.6% | |
| Lowercase Letter | 39621 | 1.8% | |
| Decimal Number | 34503 | 1.6% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| A | 341693 | 16.0% | |
| N | 168779 | 7.9% | |
| L | 144492 | 6.8% | |
| S | 128700 | 6.0% | |
| O | 128454 | 6.0% | |
| I | 127286 | 6.0% | |
| T | 113929 | 5.3% | |
| R | 109802 | 5.1% | |
| C | 102063 | 4.8% | |
| M | 99895 | 4.7% | |
| E | 95498 | 4.5% | |
| B | 90009 | 4.2% | |
| G | 88646 | 4.2% | |
| U | 78383 | 3.7% | |
| P | 70221 | 3.3% | |
| D | 65468 | 3.1% | |
| Y | 32701 | 1.5% | |
| V | 30194 | 1.4% | |
| H | 24910 | 1.2% | |
| K | 22690 | 1.1% | |
| W | 18010 | 0.8% | |
| Z | 14441 | 0.7% | |
| F | 12000 | 0.6% | |
| Q | 11921 | 0.6% | |
| J | 10196 | 0.5% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 2 | 16179 | 46.9% | |
| 1 | 7746 | 22.5% | |
| 3 | 4341 | 12.6% | |
| 4 | 1771 | 5.1% | |
| 5 | 1151 | 3.3% | |
| 8 | 799 | 2.3% | |
| 6 | 733 | 2.1% | |
| 0 | 733 | 2.1% | |
| 9 | 555 | 1.6% | |
| 7 | 495 | 1.4% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| n | 26399 | 66.6% | |
| a | 13201 | 33.3% | |
| s | 6 | < 0.1% | |
| l | 6 | < 0.1% | |
| c | 3 | < 0.1% | |
| r | 3 | < 0.1% | |
| o | 3 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 2173820 | 98.4% | |
| Common | 34503 | 1.6% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| A | 341693 | 15.7% | |
| N | 168779 | 7.8% | |
| L | 144492 | 6.6% | |
| S | 128700 | 5.9% | |
| O | 128454 | 5.9% | |
| I | 127286 | 5.9% | |
| T | 113929 | 5.2% | |
| R | 109802 | 5.1% | |
| C | 102063 | 4.7% | |
| M | 99895 | 4.6% | |
| E | 95498 | 4.4% | |
| B | 90009 | 4.1% | |
| G | 88646 | 4.1% | |
| U | 78383 | 3.6% | |
| P | 70221 | 3.2% | |
| D | 65468 | 3.0% | |
| Y | 32701 | 1.5% | |
| V | 30194 | 1.4% | |
| n | 26399 | 1.2% | |
| H | 24910 | 1.1% | |
| K | 22690 | 1.0% | |
| W | 18010 | 0.8% | |
| Z | 14441 | 0.7% | |
| a | 13201 | 0.6% | |
| F | 12000 | 0.6% | |
| Other values (8) | 25956 | 1.2% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 2 | 16179 | 46.9% | |
| 1 | 7746 | 22.5% | |
| 3 | 4341 | 12.6% | |
| 4 | 1771 | 5.1% | |
| 5 | 1151 | 3.3% | |
| 8 | 799 | 2.3% | |
| 6 | 733 | 2.1% | |
| 0 | 733 | 2.1% | |
| 9 | 555 | 1.6% | |
| 7 | 495 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 2208323 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| A | 341693 | 15.5% | |
| N | 168779 | 7.6% | |
| L | 144492 | 6.5% | |
| S | 128700 | 5.8% | |
| O | 128454 | 5.8% | |
| I | 127286 | 5.8% | |
| T | 113929 | 5.2% | |
| R | 109802 | 5.0% | |
| C | 102063 | 4.6% | |
| M | 99895 | 4.5% | |
| E | 95498 | 4.3% | |
| B | 90009 | 4.1% | |
| G | 88646 | 4.0% | |
| U | 78383 | 3.5% | |
| P | 70221 | 3.2% | |
| D | 65468 | 3.0% | |
| Y | 32701 | 1.5% | |
| V | 30194 | 1.4% | |
| n | 26399 | 1.2% | |
| H | 24910 | 1.1% | |
| K | 22690 | 1.0% | |
| W | 18010 | 0.8% | |
| 2 | 16179 | 0.7% | |
| Z | 14441 | 0.7% | |
| a | 13201 | 0.6% | |
| Other values (18) | 56280 | 2.5% |
| Distinct count | 213954 |
|---|---|
| Unique (%) | 80.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8787710785094583 |
|---|---|
| Minimum | 0.00018483832807570977 |
| Maximum | 8125.818219866071 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0.0001848383281 |
|---|---|
| 5-th percentile | 0.2350499094 |
| Q1 | 0.4974800131 |
| median | 0.7212358021 |
| Q3 | 1 |
| 95-th percentile | 1.694816613 |
| Maximum | 8125.81822 |
| Range | 8125.818035 |
| Interquartile range (IQR) | 0.5025199869 |
Descriptive statistics
| Standard deviation | 15.8480096 |
|---|---|
| Coefficient of variation (CV) | 18.03428673 |
| Kurtosis | 259056.1929 |
| Mean | 0.8787710785 |
| Median Absolute Deviation (MAD) | 0.2787641979 |
| Skewness | 505.5685903 |
| Sum | 234360.3377 |
| Variance | 251.1594082 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 52738 | 19.8% | |
| 0.6942840599 | 1 | < 0.1% | |
| 0.5754498646 | 1 | < 0.1% | |
| 0.4513185097 | 1 | < 0.1% | |
| 0.81235174 | 1 | < 0.1% | |
| 0.3780239854 | 1 | < 0.1% | |
| 1.173605703 | 1 | < 0.1% | |
| 1.052564956 | 1 | < 0.1% | |
| 0.4916824761 | 1 | < 0.1% | |
| 0.6870704485 | 1 | < 0.1% | |
| 1.021652111 | 1 | < 0.1% | |
| 0.3555187972 | 1 | < 0.1% | |
| 0.5332895341 | 1 | < 0.1% | |
| 0.5030171573 | 1 | < 0.1% | |
| 0.5413449557 | 1 | < 0.1% | |
| 1.52287231 | 1 | < 0.1% | |
| 0.2269062251 | 1 | < 0.1% | |
| 0.5001980867 | 1 | < 0.1% | |
| 0.2282350544 | 1 | < 0.1% | |
| 0.651661521 | 1 | < 0.1% | |
| 0.9983052067 | 1 | < 0.1% | |
| 0.9618422813 | 1 | < 0.1% | |
| 0.2288801258 | 1 | < 0.1% | |
| 1.434794527 | 1 | < 0.1% | |
| 0.6538358244 | 1 | < 0.1% | |
| Other values (213929) | 213929 | 80.2% |
| Value | Count | Frequency (%) | |
| 0.0001848383281 | 1 | < 0.1% | |
| 0.0002213324309 | 1 | < 0.1% | |
| 0.0002581069569 | 1 | < 0.1% | |
| 0.000295405497 | 1 | < 0.1% | |
| 0.000300471723 | 1 | < 0.1% | |
| 0.0003491139202 | 1 | < 0.1% | |
| 0.0005744485294 | 1 | < 0.1% | |
| 0.0009711671271 | 1 | < 0.1% | |
| 0.001161871719 | 1 | < 0.1% | |
| 0.001396669927 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8125.81822 | 1 | < 0.1% | |
| 569.5617416 | 1 | < 0.1% | |
| 408.4509371 | 1 | < 0.1% | |
| 304.4175781 | 1 | < 0.1% | |
| 183.0441983 | 1 | < 0.1% | |
| 172.6016296 | 1 | < 0.1% | |
| 129.3310291 | 1 | < 0.1% | |
| 110.5324805 | 1 | < 0.1% | |
| 110.0046084 | 1 | < 0.1% | |
| 103.8020166 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| cellId | data | voice | sms | revenueData | revenueVoice | revenueSms | yieldData | yieldVoice | yieldSms | brand | unitId | dataScaleFactor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | ROBIROSAF-1 | 88016.369511 | 0.0 | 0.0 | 13146.840949 | 0.000000 | 0.000000 | 0.149368 | 0.000000 | 0.000000 | Globe Postpaid | ROBIROSA | 0.864947 |
| 1 | CABARUANPGSNH-43 | 1058.925083 | 0.0 | 0.0 | 95.938449 | 0.000000 | 0.000000 | 0.090600 | 0.000000 | 0.000000 | Globe Postpaid | CABARUANPGSN | 0.503747 |
| 2 | UPTWNBPO2BGC-3 | 1606.904400 | 391.0 | 1155.0 | 139.672560 | 514.348372 | 1935.673365 | 0.086920 | 1.315469 | 1.675908 | Globe Postpaid | UPTWNBPO2BGC | 1.000000 |
| 3 | CALASIAO6Z-LA_4RFS | 919.774213 | 2718.0 | 256.0 | 32.562313 | 1441.404061 | 95.681845 | 0.035403 | 0.530318 | 0.373757 | Globe Postpaid | CALASIAO6 | 0.833502 |
| 4 | PENARANDAZ-B | 20432.604806 | 7121.0 | 3054.0 | 1464.652526 | 12750.752944 | 2681.352630 | 0.071682 | 1.790585 | 0.877981 | Globe Postpaid | PENARANDA | 0.729193 |
| 5 | RCARASJ-2 | 3308.048463 | 80.0 | 1374.0 | 230.192187 | 131.639278 | 557.721388 | 0.069585 | 1.645491 | 0.405911 | Globe Postpaid | RCARAS | 0.466188 |
| 6 | MANIPONSTBAMBANTAREMF-12 | 179.814400 | 0.0 | 0.0 | 14.224609 | 0.000000 | 0.000000 | 0.079107 | 0.000000 | 0.000000 | Globe Postpaid | NaN | 1.000000 |
| 7 | SPLASHVALODZ-L1_4RFS | 7499.026116 | 1412.0 | 618.0 | 420.346967 | 2020.774216 | 1077.668490 | 0.056054 | 1.431143 | 1.743800 | Globe Postpaid | SPLASHVALOD | 0.695699 |
| 8 | ROBINSON1MLAZ-3_4RFS | 17790.027561 | 13820.0 | 5763.0 | 2163.180985 | 28888.749862 | 7480.054688 | 0.121595 | 2.090358 | 1.297945 | Globe Postpaid | ROBINSON1MLA | 3.017338 |
| 9 | BALINGASAF-13 | 341.102234 | 0.0 | 0.0 | 24.839736 | 0.000000 | 0.000000 | 0.072822 | 0.000000 | 0.000000 | Globe Postpaid | BALINGASA | 0.677181 |
Last rows
| cellId | data | voice | sms | revenueData | revenueVoice | revenueSms | yieldData | yieldVoice | yieldSms | brand | unitId | dataScaleFactor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 266681 | MARGRNVILPRQK-143 | 3263.987714 | 0.0 | 0.0 | 70.191641 | 0.000000 | 0.000000 | 0.021505 | 0.000000 | 0.000000 | Globe Postpaid | MARGRNVILPRQ | 0.277953 |
| 266682 | IBARRAH-41 | 127571.951609 | 0.0 | 0.0 | 10598.560673 | 0.000000 | 0.000000 | 0.083079 | 0.000000 | 0.000000 | Globe Postpaid | IBARRA | 0.408420 |
| 266683 | SJBULACANX-1 | 0.000000 | 1.0 | 35.0 | 0.000000 | 1.900022 | 11.377079 | 0.000000 | 1.900022 | 0.325059 | Globe Postpaid | SJBULACAN | 1.000000 |
| 266684 | CENACLEH-32 | 29494.948818 | 0.0 | 0.0 | 2138.178337 | 0.000000 | 0.000000 | 0.072493 | 0.000000 | 0.000000 | Globe Postpaid | CENACLE | 0.279792 |
| 266685 | DISTRICTNPTF-11 | 25823.053020 | 0.0 | 0.0 | 2165.103292 | 0.000000 | 0.000000 | 0.083844 | 0.000000 | 0.000000 | Globe Postpaid | DISTRICTNPT | 0.114151 |
| 266686 | BLIWAGESTF-101 | 11954.628195 | 0.0 | 0.0 | 827.352105 | 0.000000 | 0.000000 | 0.069208 | 0.000000 | 0.000000 | Globe Postpaid | BLIWAGEST | 1.919972 |
| 266687 | BONISERVJ-D | 4168.058614 | 374.0 | 2295.0 | 461.776911 | 569.424758 | 261.252073 | 0.110789 | 1.522526 | 0.113835 | Globe Postpaid | BONISERV | 1.097294 |
| 266688 | TLISAH-32 | 9764.534795 | 0.0 | 0.0 | 919.850921 | 0.000000 | 0.000000 | 0.094203 | 0.000000 | 0.000000 | Globe Postpaid | TLISA | 0.751377 |
| 266689 | CLAVR2-2 | 988.000700 | 2240.0 | 4081.0 | 103.553095 | 2937.090399 | 3845.366712 | 0.104811 | 1.311201 | 0.942261 | Globe Postpaid | CLAVR2 | 1.000000 |
| 266690 | LUNACAF-13 | 209.442671 | 0.0 | 0.0 | 12.861845 | 0.000000 | 0.000000 | 0.061410 | 0.000000 | 0.000000 | Globe Postpaid | LUNACA | 0.261211 |